/******************************************************;
*This do file creates data from the 2000 Form 3 Census on number of nurses

******************************************************/

capture clear
clear matrix
clear mata
capture macro drop _all
set mem 1000m
set more off

#delimit ;

***SET DIRECTORY STRUCTURE***;
global data 
global data_save 

******************************************************;
*2000 Census;
use "${data}Census2000_10percent.dta", clear;

*drop ofws;
drop if overseas==1;

*OCCUPATION AND NURSE DEGREE VARIABLES;
*Note: in 2000 data, can only get nurse/midwife. Can't identify nurses separately;
gen nurse_midwife=1 if usocc==223;

*COLLAPSE DATA TO GET COUNTS OF NURSES, HEALTH DEGREES, AND THOSE ATTENDING SCHOOL OUT OF PROVINCE BY PROVINCE;
collapse (sum) nurse_midwife [pw=popwgt], by(prv);

gen year=2000;

save "${data_save}Census_2000_nurse.dta", replace;
